/*
PostgreSQL Backup
Database: RiversGovernance_DB/public
Backup Time: 2020-04-10 16:11:02
*/

DROP TABLE IF EXISTS "public"."sys_api_monitor_log";
DROP TABLE IF EXISTS "public"."sys_department_function_re";
DROP TABLE IF EXISTS "public"."sys_department_info";
DROP TABLE IF EXISTS "public"."sys_department_layertree_re";
DROP TABLE IF EXISTS "public"."sys_department_role_re";
DROP TABLE IF EXISTS "public"."sys_exception_log_info";
DROP TABLE IF EXISTS "public"."sys_function_cfg";
DROP TABLE IF EXISTS "public"."sys_layertree_cfg";
DROP TABLE IF EXISTS "public"."sys_message";
DROP TABLE IF EXISTS "public"."sys_operation_log_info";
DROP TABLE IF EXISTS "public"."sys_post_info";
DROP TABLE IF EXISTS "public"."sys_role_info";
DROP TABLE IF EXISTS "public"."sys_role_permission_re";
DROP TABLE IF EXISTS "public"."sys_user_department_re";
DROP TABLE IF EXISTS "public"."sys_user_function_re";
DROP TABLE IF EXISTS "public"."sys_user_info";
DROP TABLE IF EXISTS "public"."sys_user_post_re";
DROP TABLE IF EXISTS "public"."sys_user_role_re";
DROP TABLE IF EXISTS "public"."sys_user_treelayer_re";
DROP VIEW IF EXISTS "public"."view_sys_user";
DROP VIEW IF EXISTS "public"."view_sys_user_role";
CREATE TABLE "sys_api_monitor_log" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "controller_name" varchar(100) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "action_name" varchar(100) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "start_time" timestamp(6) NOT NULL,
  "end_time" timestamp(6) NOT NULL,
  "action_params" varchar(500) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "http_header" varchar(500) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "http_method" varchar(20) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "request_ip" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "result_code" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "request_path" varchar(500) COLLATE "pg_catalog"."default" NOT NULL
)
;ALTER TABLE "sys_api_monitor_log" OWNER TO "postgres";COMMENT ON COLUMN "sys_api_monitor_log"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_api_monitor_log"."controller_name" IS '控制器名称';COMMENT ON COLUMN "sys_api_monitor_log"."action_name" IS 'Action名称';COMMENT ON COLUMN "sys_api_monitor_log"."start_time" IS '请求开始时间';COMMENT ON COLUMN "sys_api_monitor_log"."end_time" IS '请求结束时间';COMMENT ON COLUMN "sys_api_monitor_log"."action_params" IS 'action参数';COMMENT ON COLUMN "sys_api_monitor_log"."http_header" IS 'Http请求头';COMMENT ON COLUMN "sys_api_monitor_log"."http_method" IS 'Http请求方式';COMMENT ON COLUMN "sys_api_monitor_log"."request_ip" IS '请求的IP地址';COMMENT ON COLUMN "sys_api_monitor_log"."result_code" IS '请求结果返回码';COMMENT ON COLUMN "sys_api_monitor_log"."request_path" IS '请求路径';COMMENT ON TABLE "sys_api_monitor_log" IS '接口服务  接口请求记录信息表';
CREATE TABLE "sys_department_function_re" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "group_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "function_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL
)
;ALTER TABLE "sys_department_function_re" OWNER TO "postgres";COMMENT ON COLUMN "sys_department_function_re"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_department_function_re"."group_id" IS '用户组唯一标识符';COMMENT ON COLUMN "sys_department_function_re"."function_id" IS '功能唯一标识符';COMMENT ON TABLE "sys_department_function_re" IS '部门与功能关联表';
CREATE TABLE "sys_department_info" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "parent_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "name" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "sort" float4 NOT NULL DEFAULT 0,
  "leader" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "phone" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "email" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "remarks" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "creator_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "creator_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "create_date" timestamp(6) NOT NULL DEFAULT '2020-03-17 13:36:13.504035'::timestamp without time zone,
  "modifier_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "modifier_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "modifier_date" timestamp(6) NOT NULL DEFAULT '2020-03-17 13:36:13.504035'::timestamp without time zone,
  "is_valid" bool NOT NULL DEFAULT true,
  "is_deleted" bool NOT NULL DEFAULT false
)
;ALTER TABLE "sys_department_info" OWNER TO "postgres";COMMENT ON COLUMN "sys_department_info"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_department_info"."parent_id" IS '父节点唯一标识符';COMMENT ON COLUMN "sys_department_info"."name" IS '部门名称';COMMENT ON COLUMN "sys_department_info"."sort" IS '排序';COMMENT ON COLUMN "sys_department_info"."leader" IS '领导人名称';COMMENT ON COLUMN "sys_department_info"."phone" IS '联系电话';COMMENT ON COLUMN "sys_department_info"."email" IS '邮件地址';COMMENT ON COLUMN "sys_department_info"."remarks" IS '备注';COMMENT ON COLUMN "sys_department_info"."creator_id" IS '创建者';COMMENT ON COLUMN "sys_department_info"."creator_name" IS '创建者姓名';COMMENT ON COLUMN "sys_department_info"."create_date" IS '创建日期';COMMENT ON COLUMN "sys_department_info"."modifier_id" IS '修改者';COMMENT ON COLUMN "sys_department_info"."modifier_name" IS '修改者姓名';COMMENT ON COLUMN "sys_department_info"."modifier_date" IS '修改者日期';COMMENT ON COLUMN "sys_department_info"."is_valid" IS '是否有效';COMMENT ON COLUMN "sys_department_info"."is_deleted" IS '是否被逻辑删除';COMMENT ON TABLE "sys_department_info" IS '部门表';
CREATE TABLE "sys_department_layertree_re" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "department_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "treelayer_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL
)
;ALTER TABLE "sys_department_layertree_re" OWNER TO "postgres";COMMENT ON COLUMN "sys_department_layertree_re"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_department_layertree_re"."department_id" IS '部门编号';COMMENT ON COLUMN "sys_department_layertree_re"."treelayer_id" IS '图层编号';COMMENT ON TABLE "sys_department_layertree_re" IS '部门与树图层关联表';
CREATE TABLE "sys_department_role_re" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "department_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "role_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL
)
;ALTER TABLE "sys_department_role_re" OWNER TO "postgres";COMMENT ON COLUMN "sys_department_role_re"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_department_role_re"."department_id" IS '部门唯一标识符';COMMENT ON COLUMN "sys_department_role_re"."role_id" IS '角色唯一标识符';COMMENT ON TABLE "sys_department_role_re" IS '部门—角色关系表';
CREATE TABLE "sys_exception_log_info" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "exception_type" int4 NOT NULL,
  "system_type" int4 NOT NULL,
  "exception_title" varchar(100) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "detail" varchar(500) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "create_date" timestamp(6) NOT NULL DEFAULT '2020-03-31 13:24:30.944286'::timestamp without time zone,
  "status" int4 NOT NULL DEFAULT 100
)
;ALTER TABLE "sys_exception_log_info" OWNER TO "postgres";COMMENT ON COLUMN "sys_exception_log_info"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_exception_log_info"."exception_type" IS '异常类型 100：警告  101：严重警告';COMMENT ON COLUMN "sys_exception_log_info"."system_type" IS '系统类型';COMMENT ON COLUMN "sys_exception_log_info"."exception_title" IS '异常标题';COMMENT ON COLUMN "sys_exception_log_info"."detail" IS '操作明细';COMMENT ON COLUMN "sys_exception_log_info"."create_date" IS '创建日期';COMMENT ON COLUMN "sys_exception_log_info"."status" IS '状态 100-未解决，101-已解决';COMMENT ON TABLE "sys_exception_log_info" IS '异常日志记录表';
CREATE TABLE "sys_function_cfg" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "parent_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "icon_font" varchar(100) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "level" int4 NOT NULL DEFAULT 1,
  "link_url" varchar(255) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "system_type" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "shortcut" varchar(50) COLLATE "pg_catalog"."default" DEFAULT ''::character varying,
  "function_type" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "sort" float4 NOT NULL DEFAULT 0,
  "describe" varchar(100) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "creator_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "creator_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "create_date" timestamp(6) NOT NULL DEFAULT '2020-03-17 13:41:02.267629'::timestamp without time zone,
  "modifier_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "modifier_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "modifier_date" timestamp(6) NOT NULL DEFAULT '2020-03-17 13:41:02.267629'::timestamp without time zone,
  "is_valid" bool NOT NULL DEFAULT true,
  "is_deleted" bool NOT NULL DEFAULT false,
  "target" varchar(50) COLLATE "pg_catalog"."default" DEFAULT ''::character varying,
  "is_spread" bool NOT NULL DEFAULT false,
  "system_type_name" varchar(255) COLLATE "pg_catalog"."default"
)
;ALTER TABLE "sys_function_cfg" OWNER TO "postgres";COMMENT ON COLUMN "sys_function_cfg"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_function_cfg"."parent_id" IS '父节点唯一标识符';COMMENT ON COLUMN "sys_function_cfg"."name" IS '菜单名称';COMMENT ON COLUMN "sys_function_cfg"."icon_font" IS '系统图标';COMMENT ON COLUMN "sys_function_cfg"."level" IS '级别 10：一级 20：二级 30：三级';COMMENT ON COLUMN "sys_function_cfg"."link_url" IS '链接路由地址【用于Web端】';COMMENT ON COLUMN "sys_function_cfg"."system_type" IS '系统类型【有很多系统，通过这个区分】';COMMENT ON COLUMN "sys_function_cfg"."shortcut" IS '功能快捷键';COMMENT ON COLUMN "sys_function_cfg"."function_type" IS '功能类型';COMMENT ON COLUMN "sys_function_cfg"."sort" IS '排序编号';COMMENT ON COLUMN "sys_function_cfg"."describe" IS '描述';COMMENT ON COLUMN "sys_function_cfg"."creator_id" IS '创建者';COMMENT ON COLUMN "sys_function_cfg"."creator_name" IS '创建者姓名';COMMENT ON COLUMN "sys_function_cfg"."create_date" IS '创建日期';COMMENT ON COLUMN "sys_function_cfg"."modifier_id" IS '修改者';COMMENT ON COLUMN "sys_function_cfg"."modifier_name" IS '修改者姓名';COMMENT ON COLUMN "sys_function_cfg"."modifier_date" IS '修改者日期';COMMENT ON COLUMN "sys_function_cfg"."is_valid" IS '是否有效';COMMENT ON COLUMN "sys_function_cfg"."is_deleted" IS '是否被逻辑删除';COMMENT ON COLUMN "sys_function_cfg"."target" IS '展开方式';COMMENT ON COLUMN "sys_function_cfg"."is_spread" IS '是否展开';COMMENT ON COLUMN "sys_function_cfg"."system_type_name" IS '系统类型名称';COMMENT ON TABLE "sys_function_cfg" IS '系统菜单功能配置表';
CREATE TABLE "sys_layertree_cfg" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "parent_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "name" varchar(100) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "tablename" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "memo" varchar(300) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "sort" float4 NOT NULL DEFAULT 0,
  "featureclass_name" varchar(100) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "creator_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "creator_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "create_date" timestamp(6) NOT NULL DEFAULT '2020-03-24 11:24:46.492676'::timestamp without time zone,
  "modifier_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "modifier_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "modifier_date" timestamp(6) NOT NULL DEFAULT '2020-03-24 11:24:46.492676'::timestamp without time zone,
  "is_valid" bool NOT NULL DEFAULT true,
  "is_deleted" bool NOT NULL DEFAULT false
)
;ALTER TABLE "sys_layertree_cfg" OWNER TO "postgres";COMMENT ON COLUMN "sys_layertree_cfg"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_layertree_cfg"."parent_id" IS '父节点唯一标识符';COMMENT ON COLUMN "sys_layertree_cfg"."name" IS '图层名称';COMMENT ON COLUMN "sys_layertree_cfg"."tablename" IS '图层表名';COMMENT ON COLUMN "sys_layertree_cfg"."memo" IS '图层备注';COMMENT ON COLUMN "sys_layertree_cfg"."sort" IS '排序编号';COMMENT ON COLUMN "sys_layertree_cfg"."featureclass_name" IS '图层名对应的要素类名称';COMMENT ON COLUMN "sys_layertree_cfg"."creator_id" IS '创建者';COMMENT ON COLUMN "sys_layertree_cfg"."creator_name" IS '创建者姓名';COMMENT ON COLUMN "sys_layertree_cfg"."create_date" IS '创建日期';COMMENT ON COLUMN "sys_layertree_cfg"."modifier_id" IS '修改者';COMMENT ON COLUMN "sys_layertree_cfg"."modifier_name" IS '修改者姓名';COMMENT ON COLUMN "sys_layertree_cfg"."modifier_date" IS '修改者日期';COMMENT ON COLUMN "sys_layertree_cfg"."is_valid" IS '是否有效';COMMENT ON COLUMN "sys_layertree_cfg"."is_deleted" IS '是否被逻辑删除';COMMENT ON TABLE "sys_layertree_cfg" IS '系统图层树配置表';
CREATE TABLE "sys_message" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "receiver_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "receiver_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "sender_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "sender_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "msg_type" int4 NOT NULL DEFAULT 100,
  "title" varchar(100) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "content" varchar(255) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "status" int4 NOT NULL DEFAULT 100,
  "is_deleted" bool NOT NULL DEFAULT false,
  "create_date" timestamp(6) NOT NULL DEFAULT '2020-03-17 13:38:04.745091'::timestamp without time zone
)
;ALTER TABLE "sys_message" OWNER TO "postgres";COMMENT ON COLUMN "sys_message"."id" IS '唯一编码';COMMENT ON COLUMN "sys_message"."receiver_id" IS '接受者唯一编码';COMMENT ON COLUMN "sys_message"."receiver_name" IS '接受者名称';COMMENT ON COLUMN "sys_message"."sender_id" IS '发送者ID';COMMENT ON COLUMN "sys_message"."sender_name" IS '发送者名称';COMMENT ON COLUMN "sys_message"."msg_type" IS '信息类型 100：对话信息 101：系统消息:';COMMENT ON COLUMN "sys_message"."title" IS '信息标题';COMMENT ON COLUMN "sys_message"."content" IS '信息类容';COMMENT ON COLUMN "sys_message"."status" IS '状态 100-未读，101-已读';COMMENT ON COLUMN "sys_message"."is_deleted" IS '是否被逻辑删除';COMMENT ON COLUMN "sys_message"."create_date" IS '创建日期';
CREATE TABLE "sys_operation_log_info" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "func_type" int4 NOT NULL,
  "business_title" varchar(100) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "user_code" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "user_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "ip_address" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "detail" varchar(1000) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "create_date" timestamp(6) NOT NULL DEFAULT '2020-03-17 13:35:26.874555'::timestamp without time zone
)
;ALTER TABLE "sys_operation_log_info" OWNER TO "postgres";COMMENT ON COLUMN "sys_operation_log_info"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_operation_log_info"."func_type" IS '功能类型 100：插入操作  101：更新操作 102：删除操作';COMMENT ON COLUMN "sys_operation_log_info"."business_title" IS '业务标题【用户管理】';COMMENT ON COLUMN "sys_operation_log_info"."user_code" IS '操作用户CODE';COMMENT ON COLUMN "sys_operation_log_info"."user_name" IS '操作用户名称';COMMENT ON COLUMN "sys_operation_log_info"."ip_address" IS 'IP地址';COMMENT ON COLUMN "sys_operation_log_info"."detail" IS '操作明细';COMMENT ON COLUMN "sys_operation_log_info"."create_date" IS '创建日期';COMMENT ON TABLE "sys_operation_log_info" IS '系统操作记录表';
CREATE TABLE "sys_post_info" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "name" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "sort" float4 NOT NULL DEFAULT 0,
  "brevity_code" varchar(100) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "remarks" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "creator_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "creator_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "create_date" timestamp(6) NOT NULL DEFAULT '2020-03-17 13:36:34.896596'::timestamp without time zone,
  "modifier_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "modifier_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "modifier_date" timestamp(6) NOT NULL DEFAULT '2020-03-17 13:36:34.896596'::timestamp without time zone,
  "is_valid" bool NOT NULL DEFAULT true,
  "is_deleted" bool NOT NULL DEFAULT false
)
;ALTER TABLE "sys_post_info" OWNER TO "postgres";COMMENT ON COLUMN "sys_post_info"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_post_info"."name" IS '名称';COMMENT ON COLUMN "sys_post_info"."sort" IS '排序';COMMENT ON COLUMN "sys_post_info"."brevity_code" IS '简码，CEO,CTO';COMMENT ON COLUMN "sys_post_info"."remarks" IS '备注';COMMENT ON COLUMN "sys_post_info"."creator_id" IS '创建者';COMMENT ON COLUMN "sys_post_info"."creator_name" IS '创建者姓名';COMMENT ON COLUMN "sys_post_info"."create_date" IS '创建日期';COMMENT ON COLUMN "sys_post_info"."modifier_id" IS '修改者';COMMENT ON COLUMN "sys_post_info"."modifier_name" IS '修改者姓名';COMMENT ON COLUMN "sys_post_info"."modifier_date" IS '修改者日期';COMMENT ON COLUMN "sys_post_info"."is_valid" IS '是否有效';COMMENT ON COLUMN "sys_post_info"."is_deleted" IS '是否被逻辑删除';COMMENT ON TABLE "sys_post_info" IS '职位表';
CREATE TABLE "sys_role_info" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "sort" float4 NOT NULL DEFAULT 0,
  "describe" varchar(100) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "creator_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "creator_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "create_date" timestamp(6) NOT NULL DEFAULT '2020-03-17 13:38:53.993984'::timestamp without time zone,
  "modifier_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "modifier_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "modifier_date" timestamp(6) NOT NULL DEFAULT '2020-03-17 13:38:53.993984'::timestamp without time zone,
  "is_valid" bool NOT NULL DEFAULT true,
  "is_deleted" bool NOT NULL DEFAULT false
)
;ALTER TABLE "sys_role_info" OWNER TO "postgres";COMMENT ON COLUMN "sys_role_info"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_role_info"."name" IS '角色名称';COMMENT ON COLUMN "sys_role_info"."sort" IS '排序编号';COMMENT ON COLUMN "sys_role_info"."describe" IS '用户组描述';COMMENT ON COLUMN "sys_role_info"."creator_id" IS '创建者';COMMENT ON COLUMN "sys_role_info"."creator_name" IS '创建者姓名';COMMENT ON COLUMN "sys_role_info"."create_date" IS '创建日期';COMMENT ON COLUMN "sys_role_info"."modifier_id" IS '修改者';COMMENT ON COLUMN "sys_role_info"."modifier_name" IS '修改者姓名';COMMENT ON COLUMN "sys_role_info"."modifier_date" IS '修改者日期';COMMENT ON COLUMN "sys_role_info"."is_valid" IS '是否有效';COMMENT ON COLUMN "sys_role_info"."is_deleted" IS '是否被逻辑删除';COMMENT ON TABLE "sys_role_info" IS '系统角色表';
CREATE TABLE "sys_role_permission_re" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "role_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "permission_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "permission_type" int4 NOT NULL
)
;ALTER TABLE "sys_role_permission_re" OWNER TO "postgres";COMMENT ON COLUMN "sys_role_permission_re"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_role_permission_re"."role_id" IS '角色编号';COMMENT ON COLUMN "sys_role_permission_re"."permission_id" IS '图层树或功能编号';COMMENT ON COLUMN "sys_role_permission_re"."permission_type" IS '权限类别 100图层 200功能';COMMENT ON TABLE "sys_role_permission_re" IS '角色-权限关系表';
CREATE TABLE "sys_user_department_re" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "user_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "department_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL
)
;ALTER TABLE "sys_user_department_re" OWNER TO "postgres";COMMENT ON COLUMN "sys_user_department_re"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_user_department_re"."user_id" IS '用户唯一标识符号';COMMENT ON COLUMN "sys_user_department_re"."department_id" IS '部门唯一标识符';COMMENT ON TABLE "sys_user_department_re" IS '用户-部门关系表';
CREATE TABLE "sys_user_function_re" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "user_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "function_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL
)
;ALTER TABLE "sys_user_function_re" OWNER TO "postgres";COMMENT ON COLUMN "sys_user_function_re"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_user_function_re"."user_id" IS '用户唯一标识符';COMMENT ON COLUMN "sys_user_function_re"."function_id" IS '功能唯一标识符';COMMENT ON TABLE "sys_user_function_re" IS '用户与功能关联表';
CREATE TABLE "sys_user_info" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "displayname" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "password" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "user_describe" varchar(500) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "telphone" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "mobile_phone" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "sort" float4 NOT NULL DEFAULT 0,
  "gender" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "qq" varchar(20) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "nickname" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "realname" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "email" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "office_phone" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "idnumber" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "picture_url" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "remarks" varchar(200) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "creator_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "creator_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "create_date" timestamp(6) NOT NULL DEFAULT '2020-03-17 13:38:04.745091'::timestamp without time zone,
  "modifier_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "modifier_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "modifier_date" timestamp(6) NOT NULL DEFAULT '2020-03-17 13:38:04.745091'::timestamp without time zone,
  "is_valid" bool NOT NULL DEFAULT true,
  "is_login" bool NOT NULL DEFAULT false,
  "is_deleted" bool NOT NULL DEFAULT false,
  "is_super_user" bool NOT NULL DEFAULT false
)
;ALTER TABLE "sys_user_info" OWNER TO "postgres";COMMENT ON COLUMN "sys_user_info"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_user_info"."name" IS '用户名【登录名】';COMMENT ON COLUMN "sys_user_info"."displayname" IS '用户系统显示名';COMMENT ON COLUMN "sys_user_info"."password" IS '密码';COMMENT ON COLUMN "sys_user_info"."user_describe" IS '用户描述';COMMENT ON COLUMN "sys_user_info"."telphone" IS '用户家庭电话';COMMENT ON COLUMN "sys_user_info"."mobile_phone" IS '用户手机号码';COMMENT ON COLUMN "sys_user_info"."sort" IS '排序编号';COMMENT ON COLUMN "sys_user_info"."gender" IS '性别';COMMENT ON COLUMN "sys_user_info"."qq" IS 'QQ号';COMMENT ON COLUMN "sys_user_info"."nickname" IS '用户昵称';COMMENT ON COLUMN "sys_user_info"."realname" IS '用户真实名';COMMENT ON COLUMN "sys_user_info"."email" IS '用户邮箱';COMMENT ON COLUMN "sys_user_info"."office_phone" IS '办公电话';COMMENT ON COLUMN "sys_user_info"."idnumber" IS '用户身份号码';COMMENT ON COLUMN "sys_user_info"."picture_url" IS '用户头像地址';COMMENT ON COLUMN "sys_user_info"."remarks" IS '系统隐藏备注';COMMENT ON COLUMN "sys_user_info"."creator_id" IS '创建者';COMMENT ON COLUMN "sys_user_info"."creator_name" IS '创建者姓名';COMMENT ON COLUMN "sys_user_info"."create_date" IS '创建日期';COMMENT ON COLUMN "sys_user_info"."modifier_id" IS '修改者';COMMENT ON COLUMN "sys_user_info"."modifier_name" IS '修改者姓名';COMMENT ON COLUMN "sys_user_info"."modifier_date" IS '修改者日期';COMMENT ON COLUMN "sys_user_info"."is_valid" IS '是否有效';COMMENT ON COLUMN "sys_user_info"."is_login" IS '是否登录';COMMENT ON COLUMN "sys_user_info"."is_deleted" IS '是否被逻辑删除';COMMENT ON COLUMN "sys_user_info"."is_super_user" IS '是否是超级管理员';COMMENT ON TABLE "sys_user_info" IS '用户信息表';
CREATE TABLE "sys_user_post_re" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "user_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "post_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL
)
;ALTER TABLE "sys_user_post_re" OWNER TO "postgres";COMMENT ON COLUMN "sys_user_post_re"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_user_post_re"."user_id" IS '用户唯一标识符号';COMMENT ON COLUMN "sys_user_post_re"."post_id" IS '职位唯一标识符';COMMENT ON TABLE "sys_user_post_re" IS '用户-职位系表';
CREATE TABLE "sys_user_role_re" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "user_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "role_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL
)
;ALTER TABLE "sys_user_role_re" OWNER TO "postgres";COMMENT ON COLUMN "sys_user_role_re"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_user_role_re"."user_id" IS '用户唯一标识符';COMMENT ON COLUMN "sys_user_role_re"."role_id" IS '角色唯一标识符';COMMENT ON TABLE "sys_user_role_re" IS '用户-角色关系表';
CREATE TABLE "sys_user_treelayer_re" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "user_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "treelayer_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL
)
;ALTER TABLE "sys_user_treelayer_re" OWNER TO "postgres";COMMENT ON COLUMN "sys_user_treelayer_re"."id" IS '唯一标识符';COMMENT ON COLUMN "sys_user_treelayer_re"."user_id" IS '用户唯一标识符';COMMENT ON COLUMN "sys_user_treelayer_re"."treelayer_id" IS '图层编号';COMMENT ON TABLE "sys_user_treelayer_re" IS '用户与树图层关联表';
CREATE VIEW "view_sys_user" AS  SELECT userinfo.id,
    userinfo.name,
    userinfo.password,
    userinfo.displayname,
    userinfo.gender,
    userinfo.telphone,
    userinfo.mobile_phone,
    userinfo.qq,
    userinfo.nickname,
    userinfo.realname,
    userinfo.email,
    userinfo.office_phone,
    userinfo.idnumber,
    userinfo.picture_url,
    userinfo.create_date,
    userinfo.sort,
    userinfo.is_valid,
    userinfo.is_super_user,
    userinfo.user_describe,
    array_to_string(ARRAY( SELECT view_sys_user_role.role_id
           FROM view_sys_user_role
          WHERE ((view_sys_user_role.user_id)::text = (userinfo.id)::text)), ','::text) AS role_ids,
    array_to_string(ARRAY( SELECT roleinfo.name
           FROM (view_sys_user_role userrole
             LEFT JOIN sys_role_info roleinfo ON (((userrole.role_id)::text = (roleinfo.id)::text)))
          WHERE ((userrole.user_id)::text = (userinfo.id)::text)), ','::text) AS role_names,
    array_to_string(ARRAY( SELECT sys_user_post_re.post_id
           FROM sys_user_post_re
          WHERE ((sys_user_post_re.user_id)::text = (userinfo.id)::text)), ','::text) AS post_ids,
    array_to_string(ARRAY( SELECT postinfo.name
           FROM (sys_user_post_re userpost
             LEFT JOIN sys_post_info postinfo ON (((userpost.post_id)::text = (postinfo.id)::text)))
          WHERE ((userpost.user_id)::text = (userinfo.id)::text)), ','::text) AS post_names,
    array_to_string(ARRAY( SELECT sys_user_department_re.department_id
           FROM sys_user_department_re
          WHERE ((sys_user_department_re.user_id)::text = (userinfo.id)::text)), ','::text) AS department_ids,
    array_to_string(ARRAY( SELECT departmentinfo.name
           FROM (sys_user_department_re userdepartment
             LEFT JOIN sys_department_info departmentinfo ON (((userdepartment.department_id)::text = (departmentinfo.id)::text)))
          WHERE ((userdepartment.user_id)::text = (userinfo.id)::text)), ','::text) AS department_names
   FROM sys_user_info userinfo
  WHERE (userinfo.is_deleted = false);ALTER TABLE "view_sys_user" OWNER TO "postgres";
CREATE VIEW "view_sys_user_role" AS  SELECT user_department.user_id,
    department_role.role_id,
    role_info.name
   FROM (((sys_user_department_re user_department
     LEFT JOIN sys_department_info department ON (((department.id)::text = (user_department.department_id)::text)))
     LEFT JOIN sys_department_role_re department_role ON (((user_department.department_id)::text = (department_role.department_id)::text)))
     LEFT JOIN sys_role_info role_info ON (((department_role.role_id)::text = (role_info.id)::text)))
  WHERE ((department.is_valid = true) AND (department.is_deleted = false) AND ((role_info.is_valid = true) AND (role_info.is_deleted = false)))
UNION
 SELECT user_role.user_id,
    user_role.role_id,
    role_info.name
   FROM ((sys_user_role_re user_role
     LEFT JOIN sys_user_info user_info ON (((user_role.user_id)::text = (user_info.id)::text)))
     LEFT JOIN sys_role_info role_info ON (((user_role.role_id)::text = (role_info.id)::text)))
  WHERE ((role_info.is_valid = true) AND (role_info.is_deleted = false));ALTER TABLE "view_sys_user_role" OWNER TO "postgres";
BEGIN;
LOCK TABLE "public"."sys_api_monitor_log" IN SHARE MODE;
DELETE FROM "public"."sys_api_monitor_log";
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_department_function_re" IN SHARE MODE;
DELETE FROM "public"."sys_department_function_re";
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_department_info" IN SHARE MODE;
DELETE FROM "public"."sys_department_info";
INSERT INTO "public"."sys_department_info" ("id","parent_id","name","sort","leader","phone","email","remarks","creator_id","creator_name","create_date","modifier_id","modifier_name","modifier_date","is_valid","is_deleted") VALUES ('5421261B65CBC495B23308D7D6CB533A', 'A4097C0A880CCA11AC9F08D7D61A5CA8', '勘察组', 18, '勘察组', '15245854526', 'qweqwe@qq.com', '123123123123', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-02 14:01:45.927532', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-02 14:01:45.927532', 't', 'f'),('9BCB27CC43DBC9D2E26C08D7D7754115', '', '1', 19, '1', '14780289411', '65@qq.com', '1111', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-03 10:18:09.904749', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:36:13.504035', 't', 't'),('AC31282639A9CEB1EDE508D7D790E82C', '', '1', 20, '1', '12345678909', '22@qq.com', '1', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-03 13:36:06.663036', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:36:13.504035', 't', 't'),('D45D76D41440CED30C6008D7D5200525', 'CED0822A7562C04AD21208D7D51FD0C8', '考勤部', 2, '考勤', '14825633652', '123123@qq.com', '123123', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-31 11:02:59.819843', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-31 11:02:59.819842', 't', 'f'),('8662D2D207A7C3DAE52408D7D6CB247A', '702C27A4697BCE876B2908D7D61A4553', '测试组', 13, '测试组', '15245854526', 'qweqwe@qq.com', '123123123123', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-02 14:00:27.495355', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-02 14:00:27.495354', 't', 'f'),('482ACB26CFE4C37816B308D7D5241A0F', '', '财务部', 4, '财务', '12312345612', '456@qq.com', 'QQ', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-31 11:32:12.887605', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:36:13.504035', 't', 'f'),('CED0822A7562C04AD21208D7D51FD0C8', '', '人事部', 1, '人事部老大', '18225633256', '123@qq.com', '111', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-31 11:01:31.945692', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:36:13.504035', 't', 'f'),('583084F21BA9C2A10DA508D7D6CB2CF0', '702C27A4697BCE876B2908D7D61A4553', '研发组', 12, '技术部', '15245854526', 'qweqwe@qq.com', '123123123123', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-02 14:00:41.684946', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-02 14:00:41.684945', 't', 'f'),('2507011D39EDC9EB1AC608D7D5E6C1E1', '', '部门测试', 4, '部门测试负责人1', '15245854521', 'qweqwe1@qq.com', '1231231231231', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-01 10:45:36.811718', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:36:13.504035', 't', 't'),('702C27A4697BCE876B2908D7D61A4553', '', '技术部', 11, '技术部', '15245854521', 'qweqwe@qq.com', '4', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-01 16:54:21.678221', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:36:13.504035', 't', 'f'),('A4097C0A880CCA11AC9F08D7D61A5CA8', '', '工程部', 17, '工程部', '15245854526', 'qweqwe@qq.com', '123123123123', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-01 16:55:00.824382', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:36:13.504035', 't', 'f');
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_department_layertree_re" IN SHARE MODE;
DELETE FROM "public"."sys_department_layertree_re";
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_department_role_re" IN SHARE MODE;
DELETE FROM "public"."sys_department_role_re";
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_exception_log_info" IN SHARE MODE;
DELETE FROM "public"."sys_exception_log_info";
INSERT INTO "public"."sys_exception_log_info" ("id","exception_type","system_type","exception_title","detail","create_date","status") VALUES ('F51524EC1A05C431762C08D7DB9AAFC0', 100, 100, '获取对应时间段内，操作日志数量失败', '数据库连接失败', '2020-04-09 11:36:34', 100);
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_function_cfg" IN SHARE MODE;
DELETE FROM "public"."sys_function_cfg";
INSERT INTO "public"."sys_function_cfg" ("id","parent_id","name","icon_font","level","link_url","system_type","shortcut","function_type","sort","describe","creator_id","creator_name","create_date","modifier_id","modifier_name","modifier_date","is_valid","is_deleted","target","is_spread","system_type_name") VALUES ('61DE8AD1D0D4CCDE9E7F08D7D6109CB7', '902934B08BA3C7C2B3CA08D79CF54F0F', '业务测试4', '业务', 20, '业务', '100', '', '200', 17, '业务', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-01 15:45:13.315281', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', 't', 'f', '', 'f', '运维系统'),('C8AE05B3D8844F7C8525A7D52C6FF650', '', '系统管理', 'icon-xitong', 10, '', '100', '功能快捷键', '100', 1, '目录', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-24 10:32:37', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-30 13:51:51.760314', 't', 'f', '', 'f', '运维系统'),('FAA5F0229D39C105AFBD08D7D444F20F', '0AFEDD1F2219CC67638F08D75301EDFC', '角色管理', 'icon-jueseguanli', 30, '/Authority/Role/Index', '100', '', '200', 11, '角色管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', 't', 'f', '', 'f', '运维系统'),('3771BE2AE09F4F4EB3C8A68AD78B3D61', '902934B08BA3C7C2B3CA08D79CF54F0F', '业务测试', 'icon-anjian', 20, '/Authority/Menus/Index', '100', '功能快捷键', '200', 19, '123', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-31 11:09:05', 't', 'f', '', 'f', '运维系统'),('A4B9A26F8F31C3FB5F5C08D7D2236EEC', 'C8AE05B3D8844F7C8525A7D52C6FF650', '测试顺序12', 'icon-jianzhu', 20, '测试排序测试排序12icon-jianzhu', '100,300', '', '100', 12, '测试排序测试排序测试排序12', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', 't', 't', '', 'f', '运维系统,Web客户端'),('DB86E5728AE5C0C353F908D795AEEA77', 'C8AE05B3D8844F7C8525A7D52C6FF650', '基础管理', 'icon-quanxianguankong', 20, '', '100', '功能快捷键', '100', 3, '目录', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-31 09:21:48.289488', 't', 'f', '', 'f', '运维系统'),('2AE8CB1E9B1DC46343C908D7D5DE38E6', '0AFEDD1F2219CC67638F08D75301EDFC', '岗位管理', 'icon-gaoguanxinxi', 30, '/Authority/Post/Index', '100', '', '200', 12, '', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', 't', 'f', '', 'f', '运维系统'),('D678A1004D6ACBE1BD0208D7D5E75DDC', '', '菜单测试-目录', '菜单测试1', 10, '目录', '100', '', '100', 19, '目录', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-01 10:50:20.55663', 'f', 'f', '', 'f', '运维系统'),('09A3A442CE0ACC9E6E5108D7D4447DAD', '0AFEDD1F2219CC67638F08D75301EDFC', '组织管理', 'icon-shehuishiti', 30, '/Authority/Department/Index', '100', '', '200', 11, '部门管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', 't', 'f', '', 'f', '运维系统'),('902934B08BA3C7C2B3CA08D79CF54F0F', '', '业务管理', 'icon-anjian', 10, '', '100', '功能快捷键', '100', 15, '目录', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-24 13:12:10', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-31 11:09:05.445228', 't', 'f', '', 'f', '运维系统'),('0AFEDD1F2219CC67638F08D75301EDFC', 'C8AE05B3D8844F7C8525A7D52C6FF650', '权限管理', 'icon-quanxianguankong', 20, '', '100', '功能快捷键', '100', 7, '目录', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', 't', 'f', '', 'f', '运维系统'),('670066C527C0C905EE2508D79CF4B1EC', 'DB86E5728AE5C0C353F908D795AEEA77', '消息管理', 'icon-xiaoxi', 30, '/Basic/Message/Index', '100', '功能快捷键', '200', 4, '系统消息或对话消息处理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-31 10:57:22.499843', 't', 'f', '', 'f', '运维系统'),('C2251B1684D0C24CDCA808D7D6109474', '902934B08BA3C7C2B3CA08D79CF54F0F', '业务测试3', '业务', 20, '业务', '100', '', '200', 16, '业务', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-01 15:44:59.460814', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', 't', 't', '', 'f', '运维系统'),('4563711947D8C8BCB19408D7D6108A06', '902934B08BA3C7C2B3CA08D79CF54F0F', '业务测试2', '业务', 20, '业务', '100', '', '200', 18, '业务', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-01 15:44:35.611365', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', 't', 'f', '', 'f', '运维系统'),('3771BE2AE09F4F4EB3C8A68AD78B3D65', '0AFEDD1F2219CC67638F08D75301EDFC', '菜单管理', 'icon-caidan1', 30, '/Authority/Menus/Index', '100', '功能快捷键', '200', 8, '菜单', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-24 10:36:38', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-24 10:36:43', 't', 'f', '', 'f', '运维系统'),('7033F07E42E9C25F145B08D7DAB2FA8A', '0AFEDD1F2219CC67638F08D75301EDFC', '图层管理', 'icon-tupian', 30, '/Authority/LayertreeCfg/Index', '100', '', '200', 9, '', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-07 13:17:33.808202', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-07 13:17:33.808203', 't', 'f', '', 'f', '运维系统'),('5F64B01BC048C29E235C08D5C5FF3698', '0AFEDD1F2219CC67638F08D75301EDFC', '用户管理', 'icon-keshangxinxi', 30, '/Authority/User/Index', '100', '功能快捷键', '200', 14, '菜单', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-30 13:52:01.184272', 't', 'f', '', 'f', '运维系统'),('7AB0E74C3060CF6ECB1E08D7D53C1848', 'DB86E5728AE5C0C353F908D795AEEA77', '日志管理', 'icon-log', 30, '/Basic/OperationLog/Index', '100', '', '200', 2, '', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-17 13:41:02.267629', 't', 'f', '', 'f', '运维系统'),('F8AC7731529DC1E1A42E08D7DD1E71CD', 'DB86E5728AE5C0C353F908D795AEEA77', '访问明细', 'icon-piliangxinxi', 30, '/Basic/InterfaceAccess/Index', '100', '', '200', 6, '接口访问明细。显示接口服务，接口被访问的明细信息', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-10 15:11:52.393096', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-10 15:11:52.393097', 't', 'f', '', 'f', '运维系统'),('319D80F1ED15C89E2C7D08D7DD20F61B', 'DB86E5728AE5C0C353F908D795AEEA77', '安全管理', 'icon-xianzhixiaofeiling', 30, '/Basic/Saft/Index', '100', '', '200', 5, '接口安全相关设置，白名单、黑名单等设置', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-10 15:29:53.359644', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-10 15:29:53.359646', 't', 'f', '', 'f', '运维系统');
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_layertree_cfg" IN SHARE MODE;
DELETE FROM "public"."sys_layertree_cfg";
INSERT INTO "public"."sys_layertree_cfg" ("id","parent_id","name","tablename","memo","sort","featureclass_name","creator_id","creator_name","create_date","modifier_id","modifier_name","modifier_date","is_valid","is_deleted") VALUES ('FBD52077F046CA76187F08D7DAB828E7', 'FC290A004C4DC169FAE808D7DAB81DC4', '2', '2', '2', 6, '2', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-07 13:54:39.128591', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-07 13:55:38.405646', 't', 't'),('AED2BFAC01ECCD5C133108D7D066E6EB', '', '管线图层', '', '1', 1, '1', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-24 11:24:46.492676', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-24 11:24:46.492676', 't', 'f'),('75277C76873BCD625ADA08D7D067F2E1', 'AED2BFAC01ECCD5C133108D7D066E6EB', '热水管线', '啊', 'sys_layertree_cfg', 4, '4', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-25 10:55:17.127952', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-07 14:21:22.730456', 't', 'f'),('75277C76873BCD625ADA08D7D067F2E2', 'AED2BFAC01ECCD5C133108D7D066E6EB', '自来水管线', '表名1', 'sys_layertree_cfg', 3, '4', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-25 10:55:17.127952', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-07 15:57:48.658318', 'f', 'f'),('FC290A004C4DC169FAE808D7DAB81DC4', '', '去', '1', '1', 5, '1', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-07 13:54:20.450284', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-07 13:54:20.45037', 't', 'f'),('8E4A327E032DCBB7E57408D7DAB83132', 'AED2BFAC01ECCD5C133108D7D066E6EB', '3', '3', '3', 2, '3', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-07 13:54:53.047134', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-07 13:55:33.944753', 't', 't');
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_message" IN SHARE MODE;
DELETE FROM "public"."sys_message";
INSERT INTO "public"."sys_message" ("id","receiver_id","receiver_name","sender_id","sender_name","msg_type","title","content","status","is_deleted","create_date") VALUES ('F51524EC1A05C431762C08D7DB9AAFC0', '4593B66F611AC6B7BAF108D7DA92B2F0', 'test123', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '消息测试', '给3个人发送消息，做消息测试。', 100, 'f', '2020-04-08 16:56:11.626236'),('7F36CE9A1B3EC6693F6508D7DB9AB061', '019DFBF23A76C2750B4608D7DB8A0265', '123123', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '消息测试', '给3个人发送消息，做消息测试。', 100, 'f', '2020-04-08 16:56:12.682418'),('86F8665EDBA0CFF73F9108D7DB9AB061', '578533FCCD00CF9329AA08D7DB8A0AC5', '1234', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '消息测试', '给3个人发送消息，做消息测试。', 100, 'f', '2020-04-08 16:56:12.682432'),('662AA8CFA9C3C13A3F9E08D7DB9AB061', '2700BDA2946DC897C8F408D7DB8A1455', '123123123', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '消息测试', '给3个人发送消息，做消息测试。', 100, 'f', '2020-04-08 16:56:12.682434'),('190242DF5A21C0BD3FAC08D7DB9AB061', '2D94E233C46DCE77812C08D7DB8A1E3B', 'test111', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '消息测试', '给3个人发送消息，做消息测试。', 100, 'f', '2020-04-08 16:56:12.682435'),('BE82094939A6CCEF3FCE08D7DB9AB061', '2CF1EE0A1364CF67A2B508D7D77F6966', 'test1', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '消息测试', '给3个人发送消息，做消息测试。', 100, 'f', '2020-04-08 16:56:12.682438'),('74EC0029F980C242295508D7DB9B8521', '4593B66F611AC6B7BAF108D7DA92B2F0', 'test123', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '123', '12312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312', 100, 'f', '2020-04-08 17:02:09.617133'),('46C4AC39DADDC1B1296D08D7DB9B8521', '019DFBF23A76C2750B4608D7DB8A0265', '123123', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '123', '12312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312', 100, 'f', '2020-04-08 17:02:09.617136'),('798C4F065F00C904297908D7DB9B8521', '578533FCCD00CF9329AA08D7DB8A0AC5', '1234', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '123', '12312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312', 100, 'f', '2020-04-08 17:02:09.617137'),('DD8C7901C499C20B298708D7DB9B8521', '2700BDA2946DC897C8F408D7DB8A1455', '123123123', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '123', '12312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312', 100, 'f', '2020-04-08 17:02:09.617138'),('4FC817C97833C76729A908D7DB9B8521', '2D94E233C46DCE77812C08D7DB8A1E3B', 'test111', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '123', '12312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312', 100, 'f', '2020-04-08 17:02:09.617142'),('43F9B0F5C2AEC27D29C108D7DB9B8521', '2CF1EE0A1364CF67A2B508D7D77F6966', 'test1', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '123', '12312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312', 100, 'f', '2020-04-08 17:02:09.617145'),('85D6C6F69238C5D9464B08D7DB9BB07B', '4593B66F611AC6B7BAF108D7DA92B2F0', 'test123', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '列表用户测试', '列表用户测试列表用户测试列表用户测试列表用户测试', 100, 'f', '2020-04-08 17:03:22.349727'),('43F24AAB7BC8C85E466208D7DB9BB07B', '019DFBF23A76C2750B4608D7DB8A0265', '123123', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '列表用户测试', '列表用户测试列表用户测试列表用户测试列表用户测试', 100, 'f', '2020-04-08 17:03:22.34973'),('9654174EFE5CC514466E08D7DB9BB07B', '578533FCCD00CF9329AA08D7DB8A0AC5', '1234', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '列表用户测试', '列表用户测试列表用户测试列表用户测试列表用户测试', 100, 'f', '2020-04-08 17:03:22.349731'),('560B7B39FA52C6AD467808D7DB9BB07B', '2700BDA2946DC897C8F408D7DB8A1455', '123123123', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '列表用户测试', '列表用户测试列表用户测试列表用户测试列表用户测试', 100, 'f', '2020-04-08 17:03:22.349733'),('4328DCAB6CC5C5E7468308D7DB9BB07B', '2D94E233C46DCE77812C08D7DB8A1E3B', 'test111', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '列表用户测试', '列表用户测试列表用户测试列表用户测试列表用户测试', 100, 'f', '2020-04-08 17:03:22.349734'),('09CF5A29DDBAC1C50A5708D7DB9BF475', '2D94E233C46DCE77812C08D7DB8A1E3B', 'test111', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '选中用户发送信息测试', '1选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息测试选中用户发送信息。', 100, 'f', '2020-04-08 17:05:16.39394'),('C20B35F6EB20C836549F08D7DC54B756', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '1CB598F544A7C7D82E6308D7D77EA2EC', 'test', 100, '消息测试消息测试消息测试', '消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试', 100, 'f', '2020-04-09 15:07:50.746635'),('824B1D72E2AECADB89A308D7DC54BF38', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '1CB598F544A7C7D82E6308D7D77EA2EC', 'test', 100, '消息测试消息测试消息测试消息测试', '消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试', 100, 'f', '2020-04-09 15:08:03.973157'),('1DCDE36516ECC6BCBEDE08D7DC5F82EF', '1CB598F544A7C7D82E6308D7D77EA2EC', 'test', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '老子也回复你一个试试', '老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试老子也回复你一个试试', 100, 'f', '2020-04-09 16:25:07.296837'),('A63FCBA1F4AFC6BAAA0508D7DC5FB26A', '1CB598F544A7C7D82E6308D7D77EA2EC', 'test', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '再回复你一个试试', '再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试再回复你一个试试', 100, 'f', '2020-04-09 16:26:26.955313'),('0974FB68CA5AC78BB49608D7DC54AD25', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '1CB598F544A7C7D82E6308D7D77EA2EC', 'test', 100, '消息测试', '消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试', 101, 'f', '2020-04-09 15:07:33.65075'),('6E05FB6C3993C5F5471408D7DC60B674', '1CB598F544A7C7D82E6308D7D77EA2EC', 'test', '18855C71C688CC68186A08D7C70C1CA3', 'admin', 100, '123123', '//获取最新未读信息,                    self.logicFunc.loadCurrentMessage(function () {,                        //页面初始化,                        self.initPage();,                        self.Parameters.ac.notif', 100, 'f', '2020-04-09 16:33:43.225932'),('5140E81D59CACF108CEB08D7DC54D22E', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '1CB598F544A7C7D82E6308D7D77EA2EC', 'test', 100, '消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息', '消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试消息测试', 101, 'f', '2020-04-09 15:08:35.784418');
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_operation_log_info" IN SHARE MODE;
DELETE FROM "public"."sys_operation_log_info";
INSERT INTO "public"."sys_operation_log_info" ("id","func_type","business_title","user_code","user_name","ip_address","detail","create_date") VALUES ('D21D06FA9155CFE9B23108D7D7A953AF', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"普通员工","remarks":"1","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"21E075D2AC74CB71541208D7CA5536F5","sort":7.0,"brevity_code":"USER","creator_id":"","creator_name":"","create_date":"2020-03-17 17:26:03","modifier_name":"admin","modifier_date":"2020-04-03 16:30:54","is_valid":false,"is_deleted":false}', '2020-04-03 16:30:54.96827'),('88EFCF28A977C7A9658108D7D7A953DC', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"普通员工","remarks":"1","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"21E075D2AC74CB71541208D7CA5536F5","sort":7.0,"brevity_code":"USER","creator_id":"","creator_name":"","create_date":"2020-03-17 17:26:03","modifier_name":"admin","modifier_date":"2020-04-03 16:30:55","is_valid":true,"is_deleted":false}', '2020-04-03 16:30:55.261215'),('6EE486BCE2C8CFAEB87908D7D7A953F7', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"普通员工","remarks":"1","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"21E075D2AC74CB71541208D7CA5536F5","sort":7.0,"brevity_code":"USER","creator_id":"","creator_name":"","create_date":"2020-03-17 17:26:03","modifier_name":"admin","modifier_date":"2020-04-03 16:30:55","is_valid":false,"is_deleted":false}', '2020-04-03 16:30:55.44029'),('7D3BE52B7D46C75398AF08D7D7A95417', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"普通员工","remarks":"1","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"21E075D2AC74CB71541208D7CA5536F5","sort":7.0,"brevity_code":"USER","creator_id":"","creator_name":"","create_date":"2020-03-17 17:26:03","modifier_name":"admin","modifier_date":"2020-04-03 16:30:55","is_valid":true,"is_deleted":false}', '2020-04-03 16:30:55.649191'),('56B7F4B5A134C8051C6908D7D7A95864', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"首席信息总管","remarks":"string","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"C6A345178D09C79D1D6108D7CBCC1281","sort":4.0,"brevity_code":"CIO","creator_id":"","creator_name":"","create_date":"2020-03-19 14:09:24","modifier_name":"admin","modifier_date":"2020-04-03 16:31:02","is_valid":true,"is_deleted":false}', '2020-04-03 16:31:02.861524'),('A43F0A8298FFC079657F08D7D7A95881', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"首席信息总管","remarks":"string","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"C6A345178D09C79D1D6108D7CBCC1281","sort":4.0,"brevity_code":"CIO","creator_id":"","creator_name":"","create_date":"2020-03-19 14:09:24","modifier_name":"admin","modifier_date":"2020-04-03 16:31:03","is_valid":false,"is_deleted":false}', '2020-04-03 16:31:03.053447'),('357FA624A72FC0D33D7008D7D7A958D4', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"首席信息总管","remarks":"string","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"C6A345178D09C79D1D6108D7CBCC1281","sort":4.0,"brevity_code":"CIO","creator_id":"","creator_name":"","create_date":"2020-03-19 14:09:24","modifier_name":"admin","modifier_date":"2020-04-03 16:31:03","is_valid":true,"is_deleted":false}', '2020-04-03 16:31:03.596372'),('8E3119974C5CC3D315D208D7DD15AA09', 101, '日志信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '解决异常日志信息:"B294BA3729B043D79012FDEAF72C0107"', '2020-04-10 14:09:01.298833'),('11C8DF46D5D2C51AA13308D7D7A9546A', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"普通员工","remarks":"1","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"21E075D2AC74CB71541208D7CA5536F5","sort":7.0,"brevity_code":"USER","creator_id":"","creator_name":"","create_date":"2020-03-17 17:26:03","modifier_name":"admin","modifier_date":"2020-04-03 16:30:56","is_valid":false,"is_deleted":false}', '2020-04-03 16:30:56.193358'),('86622C80000CC917BD7108D7D7A958FE', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"首席信息总管","remarks":"string","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"C6A345178D09C79D1D6108D7CBCC1281","sort":4.0,"brevity_code":"CIO","creator_id":"","creator_name":"","create_date":"2020-03-19 14:09:24","modifier_name":"admin","modifier_date":"2020-04-03 16:31:03","is_valid":false,"is_deleted":false}', '2020-04-03 16:31:03.8749'),('35D431F16081CC4B679B08D7D7A95926', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"首席信息总管","remarks":"string","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"C6A345178D09C79D1D6108D7CBCC1281","sort":4.0,"brevity_code":"CIO","creator_id":"","creator_name":"","create_date":"2020-03-19 14:09:24","modifier_name":"admin","modifier_date":"2020-04-03 16:31:04","is_valid":true,"is_deleted":false}', '2020-04-03 16:31:04.134846'),('2031CB19DA03C6EE975F08D7D7A95940', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"首席信息总管","remarks":"string","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"C6A345178D09C79D1D6108D7CBCC1281","sort":4.0,"brevity_code":"CIO","creator_id":"","creator_name":"","create_date":"2020-03-19 14:09:24","modifier_name":"admin","modifier_date":"2020-04-03 16:31:04","is_valid":false,"is_deleted":false}', '2020-04-03 16:31:04.306463'),('789288305031C1378E9A08D7D7A9598F', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"首席信息总管","remarks":"string","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"C6A345178D09C79D1D6108D7CBCC1281","sort":4.0,"brevity_code":"CIO","creator_id":"","creator_name":"","create_date":"2020-03-19 14:09:24","modifier_name":"admin","modifier_date":"2020-04-03 16:31:04","is_valid":true,"is_deleted":false}', '2020-04-03 16:31:04.823973'),('EA7EFFE5A977C77AB0F808D7D7A959AA', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"首席信息总管","remarks":"string","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"C6A345178D09C79D1D6108D7CBCC1281","sort":4.0,"brevity_code":"CIO","creator_id":"","creator_name":"","create_date":"2020-03-19 14:09:24","modifier_name":"admin","modifier_date":"2020-04-03 16:31:04","is_valid":false,"is_deleted":false}', '2020-04-03 16:31:05.001763'),('53345CC5A46CC1009C1D08D7DD170AE1', 103, '用户信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.25', '登录成功！', '2020-04-10 14:18:53.275851'),('66CFFC2753CECD5CBA4208D7DD171009', 101, '日志信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.25', '解决异常日志信息:"066C0CA1218047B0B0936582F1CB87F2"', '2020-04-10 14:19:01.927375'),('49988CBE764FC8F81FFB08D7DD112997', 102, '日志信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '删除异常日志信息:{"startTime":"2020-04-09 00:00:00","endTime":"2020-04-10 00:00:00"}', '2020-04-10 13:36:47.816699'),('F987B000B575C0C7177B08D7D7A95491', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"普通员工","remarks":"1","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"21E075D2AC74CB71541208D7CA5536F5","sort":7.0,"brevity_code":"USER","creator_id":"","creator_name":"","create_date":"2020-03-17 17:26:03","modifier_name":"admin","modifier_date":"2020-04-03 16:30:56","is_valid":true,"is_deleted":false}', '2020-04-03 16:30:56.445422'),('87E0C45724A0C7FA51B108D7D7A95A8B', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"首席信息总管","remarks":"string","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"C6A345178D09C79D1D6108D7CBCC1281","sort":4.0,"brevity_code":"CIO","creator_id":"","creator_name":"","create_date":"2020-03-19 14:09:24","modifier_name":"admin","modifier_date":"2020-04-03 16:31:05","is_valid":true,"is_deleted":false}', '2020-04-03 16:31:06.473906'),('020712BD37FECFF9FD2308D7DD191B21', 103, '用户信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '登录成功！', '2020-04-10 14:33:39.534766'),('0E9AA3A29C18C16EA0C208D7DD11623A', 103, '用户信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '登录成功！', '2020-04-10 13:38:22.840036'),('C20E71F261B0CA2BE69C08D7D7A954D2', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"普通员工","remarks":"1","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"21E075D2AC74CB71541208D7CA5536F5","sort":7.0,"brevity_code":"USER","creator_id":"","creator_name":"","create_date":"2020-03-17 17:26:03","modifier_name":"admin","modifier_date":"2020-04-03 16:30:56","is_valid":false,"is_deleted":false}', '2020-04-03 16:30:56.876695'),('E8A2D1F0495DCF148E5F08D7DD1DC8AC', 103, '用户信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '登录成功！', '2020-04-10 15:07:08.675639'),('DCA8BC3B23EACF3E889208D7DD1E71D2', 100, '功能信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '新增子节点信息:{"modifier_id":"18855C71C688CC68186A08D7C70C1CA3","parent_id":"DB86E5728AE5C0C353F908D795AEEA77","name":"访问明细","icon_font":"icon-piliangxinxi","level":30,"link_url":"/Basic/InterfaceAccess/Index","system_type":"100","function_type":"200","sort":4.0,"describe":"接口访问明细。显示接口服务，接口被访问的明细信息","creator_id":"18855C71C688CC68186A08D7C70C1CA3","creator_name":"admin","create_date":"2020-04-10 15:11:52","modifier_name":"admin","modifier_date":"2020-04-10 15:11:52","is_valid":true,"is_deleted":false,"shortcut":"","id":"F8AC7731529DC1E1A42E08D7DD1E71CD","is_spread":false,"target":"","system_type_name":"运维系统"}', '2020-04-10 15:11:52.459463'),('B3C8164D4049C5C1459C08D7DCE8E769', 103, '用户信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '登录成功！', '2020-04-10 08:48:36.916894'),('3A88D9829EADC49BC86808D7D7A954F9', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"普通员工","remarks":"1","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"21E075D2AC74CB71541208D7CA5536F5","sort":7.0,"brevity_code":"USER","creator_id":"","creator_name":"","create_date":"2020-03-17 17:26:03","modifier_name":"admin","modifier_date":"2020-04-03 16:30:57","is_valid":true,"is_deleted":false}', '2020-04-03 16:30:57.131527'),('E9323A1C4C5CC5A0FB3808D7DD20F625', 100, '功能信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '新增子节点信息:{"modifier_id":"18855C71C688CC68186A08D7C70C1CA3","parent_id":"DB86E5728AE5C0C353F908D795AEEA77","name":"安全管理","icon_font":"icon-xianzhixiaofeiling","level":30,"link_url":"/Basic/Saft/Index","system_type":"100","function_type":"200","sort":4.0,"describe":"接口安全相关设置，白名单、黑名单等设置","creator_id":"18855C71C688CC68186A08D7C70C1CA3","creator_name":"admin","create_date":"2020-04-10 15:29:53","modifier_name":"admin","modifier_date":"2020-04-10 15:29:53","is_valid":true,"is_deleted":false,"shortcut":"","id":"319D80F1ED15C89E2C7D08D7DD20F61B","is_spread":false,"target":"","system_type_name":"运维系统"}', '2020-04-10 15:29:53.459069'),('43BDB8DF1CCFCADB55F008D7DCFF2116', 103, '用户信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '登录成功！', '2020-04-10 11:27:42.609316'),('4AE9EA40C281C21BF43B08D7D7A9553B', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"普通员工","remarks":"1","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"21E075D2AC74CB71541208D7CA5536F5","sort":7.0,"brevity_code":"USER","creator_id":"","creator_name":"","create_date":"2020-03-17 17:26:03","modifier_name":"admin","modifier_date":"2020-04-03 16:30:57","is_valid":false,"is_deleted":false}', '2020-04-03 16:30:57.565185'),('7602B0140280CD3A554A08D7DD018507', 103, '用户信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.25', '登录成功！', '2020-04-10 11:44:49.276604'),('B699006E6362C934457F08D7D7A9556F', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"普通员工","remarks":"1","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"21E075D2AC74CB71541208D7CA5536F5","sort":7.0,"brevity_code":"USER","creator_id":"","creator_name":"","create_date":"2020-03-17 17:26:03","modifier_name":"admin","modifier_date":"2020-04-03 16:30:57","is_valid":true,"is_deleted":false}', '2020-04-03 16:30:57.901481'),('6316E173351DC6BC0DCF08D7DD024851', 103, '用户信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '登录成功！', '2020-04-10 11:50:16.915468'),('EB76774C1123C03847D108D7D7A9558C', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"普通员工","remarks":"1","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"21E075D2AC74CB71541208D7CA5536F5","sort":7.0,"brevity_code":"USER","creator_id":"","creator_name":"","create_date":"2020-03-17 17:26:03","modifier_name":"admin","modifier_date":"2020-04-03 16:30:58","is_valid":false,"is_deleted":false}', '2020-04-03 16:30:58.091613'),('7FE4ADFAA628C54943DE08D7DD030174', 103, '用户信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '登录成功！', '2020-04-10 11:55:27.524735'),('1013BD676D98C5691B2B08D7D7A95681', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"普通员工","remarks":"1","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"21E075D2AC74CB71541208D7CA5536F5","sort":7.0,"brevity_code":"USER","creator_id":"","creator_name":"","create_date":"2020-03-17 17:26:03","modifier_name":"admin","modifier_date":"2020-04-03 16:30:59","is_valid":true,"is_deleted":false}', '2020-04-03 16:30:59.696101'),('A6F3D0C5FB28CBCF713208D7D7A9576D', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"首席信息总管","remarks":"string","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"C6A345178D09C79D1D6108D7CBCC1281","sort":4.0,"brevity_code":"CIO","creator_id":"","creator_name":"","create_date":"2020-03-19 14:09:24","modifier_name":"admin","modifier_date":"2020-04-03 16:31:01","is_valid":false,"is_deleted":false}', '2020-04-03 16:31:01.244954'),('8BDBC47A889BC182BFEE08D7D7A9578B', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"首席信息总管","remarks":"string","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"C6A345178D09C79D1D6108D7CBCC1281","sort":4.0,"brevity_code":"CIO","creator_id":"","creator_name":"","create_date":"2020-03-19 14:09:24","modifier_name":"admin","modifier_date":"2020-04-03 16:31:01","is_valid":true,"is_deleted":false}', '2020-04-03 16:31:01.443577'),('1F6426C4DA66CB8FFD8308D7D7A957E0', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"首席信息总管","remarks":"string","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"C6A345178D09C79D1D6108D7CBCC1281","sort":4.0,"brevity_code":"CIO","creator_id":"","creator_name":"","create_date":"2020-03-19 14:09:24","modifier_name":"admin","modifier_date":"2020-04-03 16:31:01","is_valid":false,"is_deleted":false}', '2020-04-03 16:31:02.002208'),('F2C49F94B2A7CC3D875A08D7DD03AA6F', 103, '用户信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.25', '登录成功！', '2020-04-10 12:00:11.029071'),('3E57A4A83F90CA3F5FF008D7D7A9580A', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"首席信息总管","remarks":"string","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"C6A345178D09C79D1D6108D7CBCC1281","sort":4.0,"brevity_code":"CIO","creator_id":"","creator_name":"","create_date":"2020-03-19 14:09:24","modifier_name":"admin","modifier_date":"2020-04-03 16:31:02","is_valid":true,"is_deleted":false}', '2020-04-03 16:31:02.273426'),('7F3953263D8DCF55724B08D7DD0FF151', 103, '用户信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.25', '登录成功！', '2020-04-10 13:28:03.91091'),('FE4F4D919351CCD05B3908D7DD104B18', 103, '用户信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.25', '登录成功！', '2020-04-10 13:30:34.531713'),('F71E07236AB2C441F86D08D7D7A95826', 101, '岗位信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '禁用/启用岗位成功，禁用/启用岗位信息：{"name":"首席信息总管","remarks":"string","modifier_id":"18855C71C688CC68186A08D7C70C1CA3","id":"C6A345178D09C79D1D6108D7CBCC1281","sort":4.0,"brevity_code":"CIO","creator_id":"","creator_name":"","create_date":"2020-03-19 14:09:24","modifier_name":"admin","modifier_date":"2020-04-03 16:31:02","is_valid":false,"is_deleted":false}', '2020-04-03 16:31:02.460832'),('20B6A19D0229CE8AD02608D7D7A7E5F7', 102, '日志信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '删除信息:{"startTime":"2020-01-27 00:00:00","endTime":"2020-04-03 00:00:00"}', '2020-04-03 16:20:41.39479'),('CFA365D57C56CDF258D508D7DD0FFBB2', 102, '日志信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '删除异常日志信息:{"startTime":"2020-04-02 00:00:00","endTime":"2020-04-11 00:00:00"}', '2020-04-10 13:28:21.323175'),('6C3AAE53CBF2CAF8E17208D7DD1006DD', 102, '日志信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '删除异常日志信息:{"startTime":"2020-04-02 00:00:00","endTime":"2020-04-11 00:00:00"}', '2020-04-10 13:28:40.06342'),('D09E2FA11628C3679E9908D7DD102C36', 102, '日志信息管理', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '192.168.1.20', '删除异常日志信息:{"startTime":"2020-04-02 00:00:00","endTime":"2020-04-11 00:00:00"}', '2020-04-10 13:29:42.720677');
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_post_info" IN SHARE MODE;
DELETE FROM "public"."sys_post_info";
INSERT INTO "public"."sys_post_info" ("id","name","sort","brevity_code","remarks","creator_id","creator_name","create_date","modifier_id","modifier_name","modifier_date","is_valid","is_deleted") VALUES ('2CD76045B452C955325408D7CA4BE703', '人力资源', 2, 'HR', 'str2CD76045B452C955325408D7CA4BE7032CD76045B452C955325408D7CA4BE703ing', '', '', '2020-03-17 16:19:24.529274', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-03 15:30:44.818255', 't', 'f'),('21E075D2AC74CB71541208D7CA5536F5', '普通员工', 7, 'USER', '1', '', '', '2020-03-17 17:26:03.9293', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-03 16:30:59.689208', 't', 'f'),('7833D459C67DC805246608D7D5ED0184', '董事长', 1, 'CAO', '2121', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-01 11:30:20.561731', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-01 13:35:30.140236', 't', 'f'),('EAAFAC3270B7CA55F84F08D7CA552820', '项目经理', 3, 'SE', 'string', '', '', '2020-03-17 17:25:39.049574', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-01 13:37:21.242058', 't', 'f'),('44BF47E456E3C7DCD95C08D7CAE7336D', '执行总裁', 5, 'CEO', '老大', '', '', '2020-03-18 10:51:04.530827', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-01 13:37:27.595349', 't', 'f'),('1156D2E6D385C298BB2108D7CA4BFFF9', '首席技术官', 6, 'CTO', 'string', '', '', '2020-03-17 16:20:06.416815', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-01 13:38:57.350722', 't', 'f'),('C6A345178D09C79D1D6108D7CBCC1281', '首席信息总管', 4, 'CIO', 'string', '', '', '2020-03-19 14:09:24.043346', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-03 16:31:05.50993', 't', 'f');
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_role_info" IN SHARE MODE;
DELETE FROM "public"."sys_role_info";
INSERT INTO "public"."sys_role_info" ("id","name","sort","describe","creator_id","creator_name","create_date","modifier_id","modifier_name","modifier_date","is_valid","is_deleted") VALUES ('AEB7A254D1BAC1974C2008D7D521E874', '权限管理', 1, '只管理权限角色', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-31 11:16:30.678833', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-31 15:50:04.702497', 't', 'f'),('F6049D749B7FCE4F05D708D7D522439E', '业务操作', 2, '业务操作角色', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-03-31 11:19:03.624857', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-01 10:11:07.919288', 't', 'f'),('117CAB22D3A1CA9BB45D08D7D5EA88C9', '测试角色', 3, '123', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-01 11:12:39.019842', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-01 13:05:34.363818', 't', 'f'),('152EEF5ED812C366C5EF08D7DB5A495A', '晓丽', 2, '描述', '', '', '2020-04-08 09:15:12.043536', '', '', '2020-04-08 09:15:12.043618', 't', 'f'),('7102D6995395CFCCCA7108D7DB5A495A', '小天', 3, '描述', '', '', '2020-04-08 09:15:12.044093', '', '', '2020-04-08 09:15:12.044093', 't', 'f'),('4C9E76CC7C63C5F0CA8E08D7DB5A495A', '消费', 4, '描述', '', '', '2020-04-08 09:15:12.044096', '', '', '2020-04-08 09:15:12.044096', 't', 'f');
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_role_permission_re" IN SHARE MODE;
DELETE FROM "public"."sys_role_permission_re";
INSERT INTO "public"."sys_role_permission_re" ("id","role_id","permission_id","permission_type") VALUES ('B76B6F09FDC7C2FBFED808D7D60C61A1', '117CAB22D3A1CA9BB45D08D7D5EA88C9', '0AFEDD1F2219CC67638F08D75301EDFC', 200),('5C18DF5A3F04CC91C38A08D7D60C61A2', '117CAB22D3A1CA9BB45D08D7D5EA88C9', '09A3A442CE0ACC9E6E5108D7D4447DAD', 200),('3017FBA94DD6C702EDC908D7D60C61A2', '117CAB22D3A1CA9BB45D08D7D5EA88C9', '2AE8CB1E9B1DC46343C908D7D5DE38E6', 200),('A077AB0EF825C41419F108D7D60C61A3', '117CAB22D3A1CA9BB45D08D7D5EA88C9', '3771BE2AE09F4F4EB3C8A68AD78B3D65', 200),('197359E44D4FCED9535108D7D60C61A3', '117CAB22D3A1CA9BB45D08D7D5EA88C9', 'FAA5F0229D39C105AFBD08D7D444F20F', 200),('4C2878287E63CCD679DF08D7D60C61A3', '117CAB22D3A1CA9BB45D08D7D5EA88C9', '7AB0E74C3060CF6ECB1E08D7D53C1848', 200),('5F1D352A4B40C2DEA08A08D7D60C61A3', '117CAB22D3A1CA9BB45D08D7D5EA88C9', '5F64B01BC048C29E235C08D5C5FF3698', 200),('50D34F99FA0DCF8CC51D08D7D60C61A3', '117CAB22D3A1CA9BB45D08D7D5EA88C9', 'C8AE05B3D8844F7C8525A7D52C6FF650', 200),('43AEC228564ECD9F077808D7D7A31C05', 'AEB7A254D1BAC1974C2008D7D521E874', '0AFEDD1F2219CC67638F08D75301EDFC', 200),('417619A55807CE783D6F08D7D7A31C0B', 'AEB7A254D1BAC1974C2008D7D521E874', '3771BE2AE09F4F4EB3C8A68AD78B3D65', 200),('106E7314A343C3F85E8A08D7D7A31C0B', 'AEB7A254D1BAC1974C2008D7D521E874', 'FAA5F0229D39C105AFBD08D7D444F20F', 200),('BA6456103DABCAED7A3508D7D7A31C0B', 'AEB7A254D1BAC1974C2008D7D521E874', '09A3A442CE0ACC9E6E5108D7D4447DAD', 200),('6AAC3E352E2CC6649A9008D7D7A31C0B', 'AEB7A254D1BAC1974C2008D7D521E874', '2AE8CB1E9B1DC46343C908D7D5DE38E6', 200),('0E3F97047623CCE0B86408D7D7A31C0B', 'AEB7A254D1BAC1974C2008D7D521E874', '5F64B01BC048C29E235C08D5C5FF3698', 200),('78ED4FB4FAC6CB8FD50708D7D7A31C0B', 'AEB7A254D1BAC1974C2008D7D521E874', '7AB0E74C3060CF6ECB1E08D7D53C1848', 200),('FB77B945CE3FC78FFA5808D7D7A31C0B', 'AEB7A254D1BAC1974C2008D7D521E874', 'C8AE05B3D8844F7C8525A7D52C6FF650', 200),('4E960F3DF3F2C708C0C808D7DC261C1F', 'AEB7A254D1BAC1974C2008D7D521E874', 'DB86E5728AE5C0C353F908D795AEEA77', 200),('20CA022DE756C2CB405108D7DC261C4B', 'AEB7A254D1BAC1974C2008D7D521E874', '670066C527C0C905EE2508D79CF4B1EC', 200),('DC8083E43485C9825AA808D7D6D4979E', 'F6049D749B7FCE4F05D708D7D522439E', 'FAA5F0229D39C105AFBD08D7D444F20F', 200),('8F8D9F462EB0C6E50F5A08D7D6D4979F', 'F6049D749B7FCE4F05D708D7D522439E', '0AFEDD1F2219CC67638F08D75301EDFC', 200),('F7B2C1A5083CC7828AA608D7D6D4979F', 'F6049D749B7FCE4F05D708D7D522439E', 'C8AE05B3D8844F7C8525A7D52C6FF650', 200);
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_user_department_re" IN SHARE MODE;
DELETE FROM "public"."sys_user_department_re";
INSERT INTO "public"."sys_user_department_re" ("id","user_id","department_id") VALUES ('9C7424CEEFE8C3B6243808D7D790D0B5', '18855C71C688CC68186A08D7C70C1CA3', 'CED0822A7562C04AD21208D7D51FD0C8'),('A2145458ADBFC41A1E2108D7D7A31499', '1CB598F544A7C7D82E6308D7D77EA2EC', 'CED0822A7562C04AD21208D7D51FD0C8'),('0E11772D9482C89E4BCB08D7D7A31499', '1CB598F544A7C7D82E6308D7D77EA2EC', 'D45D76D41440CED30C6008D7D5200525'),('D726D6BBACEFCCE61D5708D7DA92B2F3', '4593B66F611AC6B7BAF108D7DA92B2F0', 'CED0822A7562C04AD21208D7D51FD0C8');
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_user_function_re" IN SHARE MODE;
DELETE FROM "public"."sys_user_function_re";
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_user_info" IN SHARE MODE;
DELETE FROM "public"."sys_user_info";
INSERT INTO "public"."sys_user_info" ("id","name","displayname","password","user_describe","telphone","mobile_phone","sort","gender","qq","nickname","realname","email","office_phone","idnumber","picture_url","remarks","creator_id","creator_name","create_date","modifier_id","modifier_name","modifier_date","is_valid","is_login","is_deleted","is_super_user") VALUES ('4593B66F611AC6B7BAF108D7DA92B2F0', 'test123', '123123', '4297F44B13955235245B2497399D7A93', '', '', '15242545258', 4, '男', '', '', 'test123', '', '', '15242545251', '/src/face.jpg', '', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-07 09:26:29.841708', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-07 09:26:29.841736', 't', 'f', 'f', 'f'),('AFC15377BFACCEE0D13508D7DB8AA30C', 'a2', '222', '', '', '', '17828910321', 0, '男', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-08 15:01:18.371053', '', '', '2020-04-08 15:01:18.371054', 't', 'f', 't', 'f'),('46F13775B99CC1BB692508D7DB8AA30D', 'a3', '333', '', '', '', '17828910321', 0, '男', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-08 15:01:18.374943', '', '', '2020-04-08 15:01:18.374943', 't', 'f', 't', 'f'),('5612CEF04D7AC7413FB208D7DB8AA30E', 'c1', '444', '', '', '', '17828910321', 0, '女', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-08 15:01:18.380436', '', '', '2020-04-08 15:01:18.380436', 't', 'f', 't', 'f'),('019DFBF23A76C2750B4608D7DB8A0265', '123123', '123123123', '4297F44B13955235245B2497399D7A93', '', '', '15242545258', 5, '男', '', '', '123123', '', '', '15242545251', '/src/face.jpg', '', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-08 14:56:48.836082', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-08 14:56:48.836098', 't', 'f', 'f', 'f'),('578533FCCD00CF9329AA08D7DB8A0AC5', '1234', '123123', '4297F44B13955235245B2497399D7A93', '', '', '15242545258', 6, '男', '', '', '123123', '', '', '123123', '/src/face.jpg', '', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-08 14:57:02.887774', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-08 14:57:02.887788', 't', 'f', 'f', 'f'),('2700BDA2946DC897C8F408D7DB8A1455', '123123123', '123123', '4297F44B13955235245B2497399D7A93', '', '', '15242545258', 7, '男', '', '', '123123123', '', '', '15242545251', '/src/face.jpg', '', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-08 14:57:18.935065', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-08 14:57:18.93508', 't', 'f', 'f', 'f'),('2D94E233C46DCE77812C08D7DB8A1E3B', 'test111', '123123', '4297F44B13955235245B2497399D7A93', '', '15242545252', '15242545258', 8, '男', '', '', '123123', '', '', '123123', '/src/face.jpg', '', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-08 14:57:35.540049', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-08 14:57:35.540062', 't', 'f', 'f', 'f'),('1CB598F544A7C7D82E6308D7D77EA2EC', 'test', '15242545256', '4297F44B13955235245B2497399D7A93', '123123123123123', '15242545252', '15242545258', 2, '男', '15242545257', '15242545258', '测试账户', 'qweqwe@qq.com', '15242545254', '15242545251', '/src/UserImage/200403EA40DAB9BD0A46E68D1024F7216A79AD.png', '', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-03 11:25:19.546211', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-03 15:46:12.136787', 't', 'f', 'f', 'f'),('F3B7D2B68155C3887E4908D7DB8AA30E', 'c2', '555', '', '', '', '17828910321', 0, '女', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-08 15:01:18.38204', '', '', '2020-04-08 15:01:18.382041', 't', 'f', 't', 'f'),('2CF1EE0A1364CF67A2B508D7D77F6966', 'test1', '15242545256', '4297F44B13955235245B2497399D7A93', '123123123', '15242545252', '15242545258', 3, '男', '15242545257', '15242545258', '测试账户1', 'qweqwe@qq.com', '15242545254', '15242545251', '/src/face.jpg', '', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-03 11:30:52.536702', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-03 11:30:52.537378', 't', 'f', 'f', 'f'),('6F8DCE3542AEC8D5769C08D7DB8AA30F', 'c3', '666', '', '', '', '17828910321', 0, '女', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-08 15:01:18.388395', '', '', '2020-04-08 15:01:18.388395', 't', 'f', 't', 'f'),('6F8DCE3542AEC8D5769C08D7DB8AA301', 'c4', '666', '', '', '', '17828910321', 0, '女', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-08 15:01:18.388395', '', '', '2020-04-08 15:01:18.388395', 't', 'f', 't', 'f'),('6F8DCE3542AEC8D5769C08D7DB8AA302', 'c5', '666', '', '', '', '17828910321', 0, '女', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-08 15:01:18.388395', '', '', '2020-04-08 15:01:18.388395', 't', 'f', 't', 'f'),('B29D4724B2ACC013BB7E08D7DC247321', 'a1', '111', '', '', '', '17828910321', 0, '男', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-09 09:22:20.474495', '', '', '2020-04-09 09:22:20.474569', 't', 'f', 't', 'f'),('9E22DB98B4AFC463E79308D7DC247323', 'a2', '222', '', '', '', '17828910321', 0, '男', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-09 09:22:20.488084', '', '', '2020-04-09 09:22:20.488085', 't', 'f', 't', 'f'),('9B7CECA7DCBBCFBDD37A08D7DB8F2223', 'a1', '111', '', '', '', '17828910321', 0, '男', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-08 15:33:29.579413', '', '', '2020-04-08 15:33:29.579414', 't', 'f', 't', 'f'),('476DAD558217CA5AA70D08D7DB8F2224', 'a2', '222', '', '', '', '17828910321', 0, '男', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-08 15:33:29.584822', '', '', '2020-04-08 15:33:29.584823', 't', 'f', 't', 'f'),('81920B23C896C9505FB108D7DB8F2225', 'a3', '333', '', '', '', '17828910321', 0, '男', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-08 15:33:29.589549', '', '', '2020-04-08 15:33:29.589549', 't', 'f', 't', 'f'),('B4607BA87AC6CC84664B08D7DB8AA30B', 'a1', '111', '', '', '', '17828910321', 0, '男', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-08 15:01:18.362308', '', '', '2020-04-08 15:01:18.362368', 't', 'f', 't', 'f'),('4434FD6C4686C7A4329608D7DB8F2226', 'c1', '444', '', '', '', '17828910321', 0, '女', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-08 15:33:29.594948', '', '', '2020-04-08 15:33:29.594949', 't', 'f', 't', 'f'),('A94624A369C5C12A871308D7DB8F2226', 'c2', '555', '', '', '', '17828910321', 0, '女', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-08 15:33:29.597115', '', '', '2020-04-08 15:33:29.597116', 't', 'f', 't', 'f'),('1A092BD57F82C5AAA82608D7DB8F2227', 'c3', '666', '', '', '', '17828910321', 0, '女', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-08 15:33:29.604511', '', '', '2020-04-08 15:33:29.604511', 't', 'f', 't', 'f'),('E4408F79EF12CDDCDD4108D7DC247324', 'a3', '333', '', '', '', '17828910321', 0, '男', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-09 09:22:20.49437', '', '', '2020-04-09 09:22:20.49437', 't', 'f', 't', 'f'),('8F276FE09A96CF6FDDA308D7DC247325', 'c1', '444', '', '', '', '17828910321', 0, '女', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-09 09:22:20.500933', '', '', '2020-04-09 09:22:20.500934', 't', 'f', 't', 'f'),('34220D0FB989CDE21EE208D7DC247326', 'c2', '555', '', '', '', '17828910321', 0, '女', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-09 09:22:20.502605', '', '', '2020-04-09 09:22:20.502605', 't', 'f', 't', 'f'),('AEF34A482976C997E88208D7DC247326', 'c3', '666', '', '', '', '17828910321', 0, '女', '', '', '', '1@qq.com', '', '', '', '', '', '', '2020-04-09 09:22:20.507765', '', '', '2020-04-09 09:22:20.507765', 't', 'f', 't', 'f'),('18855C71C688CC68186A08D7C70C1CA3', 'admin', 'admin', '4297F44B13955235245B2497399D7A93', '4297F44B13955235245B2497399D7A93', '13880306356', '13880306356', 0, '女', '123123', '12312', '李聪', '1231', '13880306356', '5137211152312128256', '/src/UserImage/2004098082EE8F07474506954DC169F9B3EB9F.png', '123123', '123', '123', '2020-03-17 13:38:04.745091', '18855C71C688CC68186A08D7C70C1CA3', 'admin', '2020-04-09 15:38:22.230941', 't', 'f', 'f', 't');
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_user_post_re" IN SHARE MODE;
DELETE FROM "public"."sys_user_post_re";
INSERT INTO "public"."sys_user_post_re" ("id","user_id","post_id") VALUES ('C3FCE990447AC7EA91FE08D7D7A31499', '1CB598F544A7C7D82E6308D7D77EA2EC', '21E075D2AC74CB71541208D7CA5536F5'),('A13F81320C71C6238CAC08D7DA92B2F3', '4593B66F611AC6B7BAF108D7DA92B2F0', '2CD76045B452C955325408D7CA4BE703');
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_user_role_re" IN SHARE MODE;
DELETE FROM "public"."sys_user_role_re";
INSERT INTO "public"."sys_user_role_re" ("id","user_id","role_id") VALUES ('7A244BFFFB67CB1ABF2908D7D7A31498', '1CB598F544A7C7D82E6308D7D77EA2EC', 'AEB7A254D1BAC1974C2008D7D521E874');
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_user_treelayer_re" IN SHARE MODE;
DELETE FROM "public"."sys_user_treelayer_re";
COMMIT;
ALTER TABLE "sys_api_monitor_log" ADD CONSTRAINT "pk_sys_api_monitor_log" PRIMARY KEY ("id");
ALTER TABLE "sys_department_function_re" ADD CONSTRAINT "pk_sys_department_function_re" PRIMARY KEY ("id");
ALTER TABLE "sys_department_layertree_re" ADD CONSTRAINT "pk_sys_department_layertree_re" PRIMARY KEY ("id");
ALTER TABLE "sys_exception_log_info" ADD CONSTRAINT "pk_sys_exception_log_info" PRIMARY KEY ("id");
ALTER TABLE "sys_function_cfg" ADD CONSTRAINT "sys_function_cfg_pkey" PRIMARY KEY ("id");
ALTER TABLE "sys_layertree_cfg" ADD CONSTRAINT "pk_sys_layertree_cfg" PRIMARY KEY ("id");
ALTER TABLE "sys_operation_log_info" ADD CONSTRAINT "pk_sys_operation_log_info" PRIMARY KEY ("id");
ALTER TABLE "sys_post_info" ADD CONSTRAINT "pk_sys_post_info" PRIMARY KEY ("id");
ALTER TABLE "sys_role_permission_re" ADD CONSTRAINT "pk_sys_role_permission_re" PRIMARY KEY ("id");
ALTER TABLE "sys_user_department_re" ADD CONSTRAINT "pk_sys_user_department_re" PRIMARY KEY ("id");
ALTER TABLE "sys_user_function_re" ADD CONSTRAINT "pk_sys_user_function_re" PRIMARY KEY ("id");
ALTER TABLE "sys_user_info" ADD CONSTRAINT "pk_sys_user_info" PRIMARY KEY ("id");
ALTER TABLE "sys_user_post_re" ADD CONSTRAINT "pk_sys_user_post_re" PRIMARY KEY ("id");
ALTER TABLE "sys_user_treelayer_re" ADD CONSTRAINT "pk_sys_user_treelayer_re" PRIMARY KEY ("id");
ALTER TABLE "sys_function_cfg" ADD CONSTRAINT "sys_function_cfg_name" UNIQUE ("name");
COMMENT ON CONSTRAINT "sys_function_cfg_name" ON "sys_function_cfg" IS '功能名称唯一';
ALTER TABLE "sys_post_info" ADD CONSTRAINT "pk_name" UNIQUE ("name");
ALTER TABLE "sys_role_info" ADD CONSTRAINT "sys_role_info_name" UNIQUE ("name");
COMMENT ON CONSTRAINT "sys_role_info_name" ON "sys_role_info" IS '角色名唯一';
